# -*_ codeing=utf-8 -*-
# @Time: 2025/10/28 22:24
# @Author: foxhuty
# @File: tree_cascade.py
# @Software: PyCharm
# @Based on python 3.10

from datetime import date
from decimal import Decimal
from sqlalchemy.orm import sessionmaker
from sqlalchemy_notes.db_main import engine
from sqlalchemy_notes.student_manager.models import Student, SexValue, Department, IdCard

with sessionmaker(bind=engine).begin() as session:
    # d1 = Department(name='研发部', pid=1, city='杭州')
    # d2 = Department(name='对外贸易部', pid=1, city='广州')
    # d3 = Department(name='人力资源部', parent=d2, city='广州')
    # d4 = Department(name='中东大区', pid=1, city='成都')
    # session.add(d1)
    # session.add(d2)
    # session.add(d4)
    idc=IdCard(card_number='512535200802252512',origin='成都',student_id=1)
    session.add(idc)
